CREATE PROCEDURE [dbo].[STIUpdateTransaction]
    @JsonResult VARCHAR(MAX),
    @Status TINYINT,
    @ResultMessage VARCHAR(MAX),
    @ResultId VARCHAR(MAX),
    @ResultInvoiceNo VARCHAR(MAX),
    @InvoiceId BIGINT
AS
UPDATE STITransaction
SET JsonResult = @JsonResult,
	ResultDate = GETDATE(),
    Status = @Status,
    ResultMessage = @ResultMessage,
    ResultId = @ResultId,
    ResultInvoiceNo = @ResultInvoiceNo
WHERE InvoiceId = @InvoiceId;
